About

Anil Kumar Kanolla is a Senior Software Engineer with over 5 years of extensive experience in SQL Server database development. He has worked extensively in OLTP, OLAP environment and development databases as a Developer in the Health Care domain of a Fortune 5th company including Health Insurance. Anil is skilled in creating SQL Server Database objects such as Tables, Views, Stored procedures, Functions, Indexes to facilitate efficient data manipulation and Data consistency. He has a strong background in Performance Tuning the SQL queries, Reports packages for better reusability. Anil has also worked in BI Development and Deployment of SSIS packages and created ETL packages with different data sources such as SQL Server, Flat Files, Excel source files, etc. and then loaded the data into destination tables by performing different kinds of transformations using SSIS packages. He is experienced in providing Logging, Error handling by using Event Handlers, and Custom Logging for SSIS Packages. Anil has good knowledge in Control Flow Task like Execute SQL Task, File System Task, and Containers (For loop, For Each loop Container). Anil has implemented check point, package configurations in packages for better reusability. He has experience in Report writing using SQL Server Reporting Services (SSRS) and created various types of reports like Tabular, Matrix, Drill Down, Drill Through, Chart, Cascading Parameterized, and Sub-reports using SSRS based on client requirements. He has also written complex Expressions and Calculations for SSRS reports with Conditional Formatting. Anil has good knowledge in PowerBI desktop, Services, and Power Components. He has created various types of reports like stacked column chart, funnel chart, pie chart, Donut chart, tables, Matrix, single card, multiple card, Heat maps, and third-party visuals. Anil has worked as a Senior Software Engineer at HTC and previously worked as a Data Engineering Analyst at UnitedHealth and Software Engineer at IBM. He holds a Bachelor of Technology in Computer Science from Jawaharlal Nehru Technological University, Kakinada. Anil is skilled in SQL, Software Engineering, Data Engineering, and ETL. He has relevant experience of 6.94 years. Anil has good communication, interpersonal skills, and analytical skills and is able to work as an active member maintaining good interaction with clients and team members.